In [1]:

    

import pickle


    

In [165]:

    

import numpy
import scipy
import pandas
import spacy
import textacy


    

In [171]:

    

k = numpy.int()


    

In [3]:

    

%matplotlib inline

import matplotlib as mpl
import matplotlib.pyplot as plt

import seaborn as sns
sns.set(style="whitegrid", color_codes=True)


    

In [177]:

    

with open('/home/immersinn/Dropbox/Analytics/NCGA/data/bill_texts_filed_content.pkl', 'rb') as f1:
    btfc = pickle.load(f1)


    

In [178]:

    

btfc = btfc.set_index(["session", "house", "bill"])


    

In [179]:

    

btfc.head()


    

    
Out[179]:






  

    

      

      

      

      
content
      
long_title
      
table_info
    
    

      
session
      
house
      
bill
      

      

      

    
  
  

    

      
2015E4
      
H
      
1
      
GENERAL ASSEMBLY OF NORTH CAROLINA  FOURTH EXT...
      
A HOUSE RESOLUTION adopting the permanent rule...
      
{'Referred to': '', 'Sponsors': 'Representativ...
    
    

      
2
      
GENERAL ASSEMBLY OF NORTH CAROLINA  FOURTH EXT...
      
A JOINT RESOLUTIOn providing for adjournment s...
      
{'Referred to': '', 'Sponsors': 'Representativ...
    
    

      
3
      
GENERAL ASSEMBLY OF NORTH CAROLINA  FOURTH EXT...
      
AN ACT to provide further REGULATORY RELIEF TO...
      
{'Short   Title': 'Regulatory Reform Act of 20...
    
    

      
4
      
GENERAL ASSEMBLY OF NORTH CAROLINA  FOURTH EXT...
      
AN ACT directing the department of transportat...
      
{'Short   Title': 'Terminate Agreement for Tol...
    
    

      
5
      
GENERAL ASSEMBLY OF NORTH CAROLINA  FOURTH EXT...
      
AN ACT to clarify the service area for communi...
      
{'Short   Title': 'Municipal Broadband Service...
    
  

In [180]:

    

with open('/home/immersinn/Dropbox/Analytics/NCGA/data/bill_page_keywords.pkl', 'rb') as f1:
    keywords = pickle.load(f1)


    

In [181]:

    

keywords = keywords.set_index(["session", "house", "bill"])


    

In [182]:

    

keywords.head()


    

    
Out[182]:






  

    

      

      

      

      
keywords
    
    

      
session
      
house
      
bill
      

    
  
  

    

      
2015E4
      
H
      
1
      
[ADOPTED, GENERAL ASSEMBLY, RESOLUTIONS, SIMPL...
    
    

      
2
      
[ADJOURNMENT, GENERAL ASSEMBLY, RESOLUTIONS, J...
    
    

      
3
      
[ADMINISTRATION DEPT., ADMINISTRATIVE CODE, AD...
    
    

      
4
      
[BRIDGES, CONTRACTS, COUNTIES, INFRASTRUCTURE,...
    
    

      
5
      
[COUNTIES, EDGECOMBE COUNTY, INFORMATION TECHN...
    
  

In [183]:

    

btfc = btfc.join(keywords, how="left")


    

In [184]:

    

btfc = pandas.DataFrame(btfc.to_records())


    

In [185]:

    

btfc.head()


    

    
Out[185]:






  

    

      

      
session
      
house
      
bill
      
content
      
long_title
      
table_info
      
keywords
    
  
  

    

      
0
      
2015E4
      
H
      
1
      
GENERAL ASSEMBLY OF NORTH CAROLINA  FOURTH EXT...
      
A HOUSE RESOLUTION adopting the permanent rule...
      
{'Referred to': '', 'Sponsors': 'Representativ...
      
[ADOPTED, GENERAL ASSEMBLY, RESOLUTIONS, SIMPL...
    
    

      
1
      
2015E4
      
H
      
2
      
GENERAL ASSEMBLY OF NORTH CAROLINA  FOURTH EXT...
      
A JOINT RESOLUTIOn providing for adjournment s...
      
{'Referred to': '', 'Sponsors': 'Representativ...
      
[ADJOURNMENT, GENERAL ASSEMBLY, RESOLUTIONS, J...
    
    

      
2
      
2015E4
      
H
      
3
      
GENERAL ASSEMBLY OF NORTH CAROLINA  FOURTH EXT...
      
AN ACT to provide further REGULATORY RELIEF TO...
      
{'Short   Title': 'Regulatory Reform Act of 20...
      
[ADMINISTRATION DEPT., ADMINISTRATIVE CODE, AD...
    
    

      
3
      
2015E4
      
H
      
4
      
GENERAL ASSEMBLY OF NORTH CAROLINA  FOURTH EXT...
      
AN ACT directing the department of transportat...
      
{'Short   Title': 'Terminate Agreement for Tol...
      
[BRIDGES, CONTRACTS, COUNTIES, INFRASTRUCTURE,...
    
    

      
4
      
2015E4
      
H
      
5
      
GENERAL ASSEMBLY OF NORTH CAROLINA  FOURTH EXT...
      
AN ACT to clarify the service area for communi...
      
{'Short   Title': 'Municipal Broadband Service...
      
[COUNTIES, EDGECOMBE COUNTY, INFORMATION TECHN...
    
  

In [189]:

    

btfc._get_numeric_data().columns.tolist()


    

    
Out[189]:





['bill']

In [135]:

    

btfc['bill'] = btfc.apply(lambda x: str(x['bill']), axis=1)


    

In [152]:

    

btfc_mini = btfc.sample(400)


    

In [155]:

    

btfc_mini.index = range(btfc_mini.shape[0])


    

In [20]:

    

textacy_preprocessor = lambda text: textacy.preprocess.preprocess_text(text,
                                                                       no_contractions=True,
                                                                       no_numbers=True,
                                                                       no_emails=True,
                                                                       no_currency_symbols=True,
                                                                       lowercase=True)


    

In [21]:

    

nlp = spacy.load("en", add_vectors=False)


    

In [22]:

    

nlp.pipeline = [nlp.tagger, nlp.parser]


    

In [153]:

    

# "texts"
texts = [textacy_preprocessor(con) for con in list(btfc_mini.content)]


    

In [156]:

    

metas = [btfc_mini.ix[btfc.index[i]][["session", "house", "bill", "keywords"]].to_dict() for i in range(btfc_mini.shape[0])]


    

In [157]:

    

metas[0]


    

    
Out[157]:





{'bill': '660',
 'house': 'H',
 'keywords': ['BOARDS',
  'COMMISSIONS',
  'CONTRACTS',
  'EDUCATION',
  'EDUCATION ADMINISTRATION',
  'EDUCATION',
  'STATE BOARD OF',
  'ELECTRONIC & OTHER MEDIA',
  'ELEMENTARY EDUCATION',
  'EMERGING TECHNOLOGIES',
  'GOVERNMENT EMPLOYEES',
  'OCCUPATIONS',
  'PUBLIC',
  'REPORTING',
  'SCIENCE & TECHNOLOGY',
  'SECONDARY EDUCATION',
  'STATE EMPLOYEES',
  'TEACHERS',
  'TEXTBOOK COMN.',
  'TEXTBOOKS'],
 'session': '2015'}

In [158]:

    

corp = textacy.Corpus(lang=nlp)


    

In [159]:

    

corp.add_texts(texts=texts, metadatas=metas,
               n_threads=8, batch_size=50)


    

In [160]:

    

corp.n_docs


    

    
Out[160]:





400

In [161]:

    

corp.n_sents


    

    
Out[161]:





22988

In [162]:

    

corp[0].metadata


    

    
Out[162]:





{'bill': '660',
 'house': 'H',
 'keywords': ['BOARDS',
  'COMMISSIONS',
  'CONTRACTS',
  'EDUCATION',
  'EDUCATION ADMINISTRATION',
  'EDUCATION',
  'STATE BOARD OF',
  'ELECTRONIC & OTHER MEDIA',
  'ELEMENTARY EDUCATION',
  'EMERGING TECHNOLOGIES',
  'GOVERNMENT EMPLOYEES',
  'OCCUPATIONS',
  'PUBLIC',
  'REPORTING',
  'SCIENCE & TECHNOLOGY',
  'SECONDARY EDUCATION',
  'STATE EMPLOYEES',
  'TEACHERS',
  'TEXTBOOK COMN.',
  'TEXTBOOKS'],
 'session': '2015'}

In [163]:

    

corp.save(path='/home/immersinn/gits/ncga/data/processed/', name='CORPUS_bills_filed_pipe01', compression='gzip')


    

In [164]:

    

corp = textacy.Corpus.load(path='/home/immersinn/gits/ncga/data/processed/',
                           name='CORPUS_bills_filed_pipe01',
                           compression='gzip')


    

In [72]:

    

n_topics = 15


    

In [46]:

    

terms_lists = (doc.to_terms_list(ngrams=1, named_entities=True, as_strings=True) for doc in corp)
doc_term_matrix, id2term = textacy.vsm.doc_term_matrix(\
                                                       terms_lists, 
                                                       weighting='tfidf', normalize=True, smooth_idf=True,
                                                       min_df=3, max_df=0.95, max_n_terms=100000)
doc_term_matrix


    

    
Out[46]:





<2098x9955 sparse matrix of type '<class 'numpy.float64'>'
	with 378044 stored elements in Compressed Sparse Row format>

In [73]:

    

model = textacy.tm.TopicModel('nmf', n_topics=n_topics)
model.fit(doc_term_matrix)
model


    

    
Out[73]:





TopicModel(n_topics=15, model=NMF)

In [77]:

    

doc_topic_matrix = model.transform(doc_term_matrix)


    

In [74]:

    

for topic_idx, top_terms in model.top_topic_terms(id2term, topics=range(5)):
    print('topic', topic_idx, ':', '   '.join(top_terms))


    

    




topic 0 : shall   state   commission   department   agency   information   contract   include   require   article
topic 1 : school   close   opening   calendar   date   closing   board   local   monday   august
topic 2 : senatorial   district   act-*number*.   relate   local   senator   senate   law   primary   short
topic 3 : tax   taxable   taxpayer   income   credit   sale   year   levy   property   business
topic 4 : fund   fiscal   appropriation   usd*number   year   dollar   appropriate   thousand   budget   highway

In [84]:

    

for topic_idx, top_docs in model.top_topic_docs(doc_topic_matrix, topics=[0,1,2,3], top_n=2):
    print(topic_idx)
    for j in top_docs:
        print(corp[j].metadata['keywords'])


    

    




0
['ADMINISTRATION DEPT.', 'ADMINISTRATIVE CODE', 'ADMINISTRATIVE RULES', 'AGRICULTURAL LAND', 'AGRICULTURE', 'AGRICULTURE COMMISSIONER', 'AGRICULTURE DEPT.', 'ANIMALS', 'APPOINTMENTS', 'ARMED FORCES', 'BEACH EROSION', 'BOARDS', 'BUDGET & MANAGEMENT OFFICE', 'BUILDING CODE COUNCIL', 'BUILDING CODES', 'CHIEF INFORMATION OFFICER', 'COASTAL RESOURCES', 'COASTAL RESOURCES COMN.', 'COLLEGES & UNIVERSITIES', 'COMMERCE', 'COMMISSIONS', 'COMMITTEES', 'COMMUNITY COLLEGES', 'COMMUNITY COLLEGES OFFICE', 'CONSERVATION', 'CONSTRUCTION', 'CONTRACTS', 'CORPORATIONS', 'NONPROFIT', 'COUNCIL OF STATE', 'COUNCILS', 'COUNTIES', 'CULTURAL RESOURCES', 'DAIRY PRODUCTS', 'DATA SYSTEMS', 'DEFINITIONS', 'DEQ', 'DMV', 'EDUCATION', 'EDUCATION BOARDS', 'ELECTRONIC GOVERNMENT', 'ELEMENTARY EDUCATION', 'EMPLOYMENT', 'ENVIRONMENT', 'ENVIRONMENTAL MANAGEMENT COMN.', 'EROSION STRUCTURES', 'FEES', 'FINANCIAL SERVICES', 'FISH & WILDLIFE', 'FISHERIES', 'FOODS & BEVERAGES', 'FRANCHISES', 'GENERAL ASSEMBLY', 'GENERAL CONTRACTORS BOARD', 'GOVERNOR', 'HEALTH SERVICES', 'HIGHER EDUCATION', 'HOUSING', 'INFORMATION TECHNOLOGY', 'INFORMATION TECHNOLOGY DEPT.', 'INFRASTRUCTURE', 'INSPECTIONS', 'INTERNET', 'INTERSTATE COOPERATION', 'KINDERGARTEN', 'LAKES & RIVERS', 'LANDLORD & TENANT', 'LANDOWNERS', 'LANDSCAPING', 'LEGISLATIVE SERVICES OFFICE', 'LICENSE PLATES', 'LICENSES & PERMITS', 'LICENSING & CERTIFICATION', 'LOANS', 'LOCAL GOVERNMENT', 'LOCAL GOVERNMENT COMN.', 'LT. GOVERNOR', 'MANAGEMENT', 'MARINE FISHERIES COMN.', 'MEDICAL CARE COMN.', 'MEMBERSHIP', 'MILITARY BASES', 'MINING & MINERAL EXTRACTION', 'MORTGAGES', 'MOTOR FLEET', 'MOTOR VEHICLES', 'MUNICIPALITIES', 'MUSEUMS', 'NAME CHANGE', 'NATURAL & CULTURAL RESOURCES DEPT.', 'NOTIFICATION', 'OCCUPATIONS', 'PLANNING & ZONING', 'PRIVACY', 'PROGRAM EVALUATION COMM.', 'PROGRAM EVALUATION DIVISION', 'PROPERTY', 'PUBLIC', 'PUBLIC HEALTH', 'PUBLIC OFFICIALS', 'PUBLIC RECORDS', 'PURCHASING', 'REAL ESTATE', 'RECORDS', 'RECYCLING', 'REFRIGERATION EXAMINERS BOARD', 'REPORTS', 'ROADS & HIGHWAYS', 'RURAL DEVELOPMENT', 'SCHOOL OF GOVERNMENT', 'SECONDARY EDUCATION', 'SENTINEL LANDSCAPES COMM.', 'SESSION LAWS', 'SOIL & WATER CONSERVATION COMN.', 'SOILS', 'SOLID WASTE', 'STATE CONTROLLER', 'STATUTE OF LIMITATIONS', 'STUDIES', 'TRANSPORTATION', 'TRANSPORTATION DEPT.', 'UNC', 'UTILITIES', 'UTILITIES COMN.', 'WASTE MANAGEMENT', 'WATER & SEWER SYSTEMS', 'WATER RESOURCES', 'WILDLIFE RESOURCES COMN.', 'ZOOS']
['ANIMALS', 'APPOINTMENTS', 'CONSTITUTION', 'NC', 'CORPORATIONS', 'FOR-PROFIT', 'CORPORATIONS', 'NONPROFIT', 'EMINENT DOMAIN', 'FISH & WILDLIFE', 'FUNDS & ACCOUNTS', 'GENERAL ASSEMBLY', 'GENERAL STATUTES', 'HUNTING & FISHING', 'LOCAL GOVERNMENT', 'LOCAL ORDINANCES', 'MEMBERSHIP', 'MUNICIPALITIES', 'PLANNING & ZONING', 'PRESIDENT PRO TEMPORE', 'PROPERTY', 'PUBLIC', 'SPEAKER', 'STUDIES', 'TASK FORCES', 'TAXATION', 'TAXES', 'CORPORATE INCOME', 'TAXES', 'INDIVIDUAL INCOME', 'TITLE CHANGE', 'ZONING MODERNIZATION TASK FORCE']
1
['BOARDS', 'CALENDAR', 'COUNTIES', 'EDUCATION', 'EDUCATION BOARDS', 'ELEMENTARY EDUCATION', 'KINDERGARTEN', 'LOCAL', 'LOCAL GOVERNMENT', 'PERSON COUNTY', 'SECONDARY EDUCATION']
['ALAMANCE COUNTY', 'BOARDS', 'BURLINGTON', 'CALENDAR', 'COUNTIES', 'EDUCATION', 'EDUCATION BOARDS', 'ELEMENTARY EDUCATION', 'KINDERGARTEN', 'LOCAL', 'LOCAL GOVERNMENT', 'MUNICIPALITIES', 'SECONDARY EDUCATION']
2
['BLANK BILL', 'CABARRUS COUNTY', 'COUNTIES', 'LOCAL', 'UNION COUNTY']
['BLANK BILL', 'BUNCOMBE COUNTY', 'COUNTIES', 'HENDERSON COUNTY', 'LOCAL', 'TRANSYLVANIA COUNTY']
3
['AGRICULTURAL EQUIPMENT', 'AGRICULTURE', 'ALCOHOLIC BEVERAGES', 'AVIATION', 'BEER & WINE', 'CASH CROPS', 'CHAPTERED', 'COMMERCE', 'CONSTRUCTION', 'CONSTRUCTION EQUIPMENT', 'CORPORATIONS', 'FOR-PROFIT', 'CORPORATIONS', 'NONPROFIT', 'COUNCIL OF STATE', 'COUNTIES', 'DEATH & DYING', 'ECONOMIC DEVELOPMENT', 'FUELS', 'FUNDS & ACCOUNTS', 'FUNERAL SERVICES', 'HEALTH SERVICES', 'HOSPITALS', 'INSURANCE', 'INSURANCE COMMISSIONER', 'INSURANCE DEPT.', 'INTEREST', 'LDC', 'LEASING', 'LICENSES & PERMITS', 'LOCAL GOVERNMENT', 'MANUFACTURING', 'MOTOR VEHICLES', 'PRESENTED', 'PUBLIC', 'PUBLIC OFFICIALS', 'RACING', 'RATIFIED', 'RECORDS', 'RETAILING', 'REVENUE DEPT.', 'SESSION LAWS', 'SHIPPING', 'SPORTS', 'SURETY & FIDELITY', 'TAX CREDITS', 'TAX DEDUCTIONS', 'TAX DISTRIBUTION', 'TAX EXEMPTIONS', 'TAX REFUNDS', 'TAXATION', 'TAXES', 'CORPORATE INCOME', 'TAXES', 'EXCISE', 'TAXES', 'FRANCHISE', 'TAXES', 'FUEL', 'TAXES', 'INDIVIDUAL INCOME', 'TAXES', 'SALES & USE', 'TAXIS', 'TOBACCO', 'TRANSPORTATION', 'WINERIES & BREWERIES']
['AGRICULTURAL EQUIPMENT', 'AGRICULTURE', 'ALCOHOLIC BEVERAGES', 'AVIATION', 'BEER & WINE', 'CASH CROPS', 'COMMERCE', 'CORPORATIONS', 'FOR-PROFIT', 'CORPORATIONS', 'NONPROFIT', 'FUELS', 'FUNDS & ACCOUNTS', 'HEALTH SERVICES', 'HOSPITALS', 'INSURANCE', 'INSURANCE DEPT.', 'INTEREST', 'LEASING', 'LICENSES & PERMITS', 'LOCAL GOVERNMENT', 'MOTOR VEHICLES', 'PUBLIC', 'RACING', 'RETAILING', 'SESSION LAWS', 'SHIPPING', 'SPORTS', 'SURETY & FIDELITY', 'TAX CREDITS', 'TAX DEDUCTIONS', 'TAX DISTRIBUTION', 'TAX EXEMPTIONS', 'TAX REFUNDS', 'TAXATION', 'TAXES', 'CORPORATE INCOME', 'TAXES', 'EXCISE', 'TAXES', 'FUEL', 'TAXES', 'INDIVIDUAL INCOME', 'TAXES', 'SALES & USE', 'TAXIS', 'TOBACCO', 'TRANSPORTATION']

In [101]:

    

pandas.Series(doc_topic_matrix.reshape((doc_topic_matrix.shape[0]*doc_topic_matrix.shape[1],))).describe(percentiles=[0.75, 0.80, 0.90, 0.95, 0.975, 0.99])


    

    
Out[101]:





count    31470.000000
mean         0.011770
std          0.035995
min          0.000000
50%          0.000000
75%          0.001839
80%          0.007263
90%          0.034381
95%          0.073173
97.5%        0.122555
99%          0.190016
max          0.399531
dtype: float64

In [102]:

    

sum(doc_topic_matrix > 0.1)


    

    
Out[102]:





array([ 83,  52,  50,  92,  67, 100,  82,  78,  72,  96,  68,  67,  52,
        25,  71])

In [85]:

    

top_term_table = []
index = []
for topic_idx, top_terms in model.top_topic_terms(id2term, top_n = 15, topics=range(n_topics)):
    index.append('topic ' + str(topic_idx))
    top_term_table.append({i : tt for i,tt in enumerate(top_terms)})
top_term_table = pandas.DataFrame(data=top_term_table, index=index)


    

In [86]:

    

top_term_table.transpose()


    

    
Out[86]:






  

    

      

      
topic 0
      
topic 1
      
topic 2
      
topic 3
      
topic 4
      
topic 5
      
topic 6
      
topic 7
      
topic 8
      
topic 9
      
topic 10
      
topic 11
      
topic 12
      
topic 13
      
topic 14
    
  
  

    

      
0
      
shall
      
school
      
senatorial
      
tax
      
fund
      
person
      
health
      
employee
      
resolution
      
school
      
vehicle
      
election
      
town
      
state
      
member
    
    

      
1
      
state
      
close
      
district
      
taxable
      
fiscal
      
court
      
child
      
employer
      
committee
      
student
      
plate
      
voter
      
property
      
united
      
board
    
    

      
2
      
commission
      
opening
      
act-*number*.
      
taxpayer
      
appropriation
      
offense
      
service
      
wage
      
senate
      
education
      
motor
      
vote
      
city
      
constitution
      
appoint
    
    

      
3
      
department
      
calendar
      
relate
      
income
      
usd*number
      
defendant
      
care
      
retirement
      
joint
      
charter
      
registration
      
candidate
      
council
      
convention
      
shall
    
    

      
4
      
agency
      
date
      
local
      
credit
      
year
      
shall
      
medicaid
      
plan
      
house
      
teacher
      
license
      
shall
      
corporate
      
amendment
      
term
    
    

      
5
      
information
      
closing
      
senator
      
sale
      
dollar
      
felony
      
program
      
tip
      
legislative
      
grade
      
division
      
county
      
charter
      
congress
      
trustee
    
    

      
6
      
contract
      
board
      
senate
      
year
      
appropriate
      
judge
      
human
      
benefit
      
representative
      
board
      
driver
      
board
      
lien
      
legislature
      
governor
    
    

      
7
      
include
      
local
      
law
      
levy
      
thousand
      
petitioner
      
plan
      
employment
      
rule
      
program
      
fee
      
ballot
      
limit
      
v
      
serve
    
    

      
8
      
require
      
monday
      
primary
      
property
      
budget
      
violation
      
department
      
state
      
bill
      
shall
      
special
      
office
      
county
      
propose
      
education
    
    

      
9
      
article
      
august
      
short
      
business
      
highway
      
order
      
division
      
leave
      
extra
      
local
      
dealer
      
elect
      
describe
      
america
      
appointment
    
    

      
10
      
report
      
education
      
20th
      
gross
      
sum
      
conviction
      
shall
      
teacher
      
resolve
      
performance
      
drive
      
petition
      
real
      
right
      
elect
    
    

      
11
      
provide
      
student
      
30th
      
code
      
grant
      
juvenile
      
provider
      
pay
      
appointment
      
score
      
transportation
      
district
      
tax
      
government
      
retirement
    
    

      
12
      
service
      
modify
      
6th
      
deduction
      
biennium
      
commit
      
committee
      
allowance
      
ratification
      
pilot
      
issue
      
hold
      
ordinance
      
application
      
council
    
    

      
13
      
public
      
day
      
15th
      
number*%
      
million
      
's
      
benefit
      
dependent
      
governor
      
unit
      
highway
      
judge
      
plat
      
twothirds
      
vacancy
    
    

      
14
      
project
      
year
      
10th
      
usd*number
      
department
      
criminal
      
medical
      
labor
      
study
      
high
      
person
      
voting
      
local
      
federal
      
commission
    
  

In [93]:

    

top_keywords = {}
for topic_idx, top_docs in model.top_topic_docs(doc_topic_matrix, topics=range(n_topics), top_n=10):
    topic = 'topic ' + str(topic_idx)
    keywords = []
    for j in top_docs:
        keywords.extend(corp[j].metadata['keywords'])
    top_keywords[topic] = set(keywords)


    

In [94]:

    

for topic_idx in range(n_topics):
    k = "topic " + str(topic_idx)
    print("\n")
    print(k + ":")
    print(top_keywords[k])


    

    





topic 0:
{'ANIMALS', 'LAKES & RIVERS', 'LANDOWNERS', 'INFORMATION TECHNOLOGY', 'APPOINTMENTS', 'DMV', 'PLANNING & ZONING', 'CHIEF INFORMATION OFFICER', 'PROGRAM EVALUATION DIVISION', 'SECONDARY EDUCATION', 'ELECTRICITY', 'TRANSPORTATION DEPT.', 'EDUCATION BOARDS', 'EMINENT DOMAIN', 'STATE BUILDINGS', 'PUBLIC OFFICIALS', 'LOANS', 'PRIVACY', 'CONTRACTS', 'RATIFIED', 'SPEED LIMIT', 'EROSION STRUCTURES', 'STATE EMPLOYEES', 'FOODS & BEVERAGES', 'HUNTING & FISHING', 'TITLE CHANGE', 'COUNCIL OF STATE', 'EMPLOYMENT', '911 BOARD', 'CHAPTERED', 'MUSEUMS', 'MANAGEMENT', 'CONSTRUCTION', 'NATURAL & CULTURAL RESOURCES DEPT.', 'SCHOOL OF GOVERNMENT', 'UNC', 'HORSES & MULES', 'LIVESTOCK & POULTRY', 'GOVERNMENT EMPLOYEES', 'BOARDS', 'STATUTE OF LIMITATIONS', 'PILOT PROGRAMS', 'COMMUNITY COLLEGES', 'LEASING', 'PUBLIC BUILDINGS', 'LOCAL ORDINANCES', 'ROADS & HIGHWAYS', 'MUNICIPALITIES', 'COLLEGES & UNIVERSITIES', 'VETERINARY MEDICINE', 'INFORMATION TECHNOLOGY DEPT.', 'UTILITIES COMN.', 'COMMITTEES', 'SENTINEL LANDSCAPES COMM.', 'OCCUPATIONS', 'FARMLAND PRESERVATION FUND', 'WETLANDS', 'WILDLIFE RESOURCES COMN.', 'STATE PROPERTY', 'TELECOMMUNICATIONS', 'MARINE FISHERIES COMN.', 'PUBLIC HEALTH', 'RURAL DEVELOPMENT', 'HIGHER EDUCATION', 'MEDICAL CARE COMN.', 'CRIMES', 'LT. GOVERNOR', 'TELESERVICES', 'INTERNET', 'HORTICULTURE', 'MANUFACTURING', 'BUDGETING', 'FOR-PROFIT', 'AGRICULTURAL WASTE', 'AGRICULTURE', 'SAFETY EQUIPMENT', 'GEOGRAPHIC INFORMATION COUNCIL', 'RECORDS', 'CULTURAL RESOURCES', 'CORPORATE INCOME', 'COMMERCE DEPT.', 'PUBLIC RECORDS', 'WEATHER', 'FRANCHISES', 'INFRASTRUCTURE', 'FUNDS & ACCOUNTS', 'MINING & MINERAL EXTRACTION', 'LICENSE PLATES', 'REPORTS', 'ADMINISTRATION DEPT.', 'BUILDING CODES', 'FISH & WILDLIFE', 'WASTE MANAGEMENT', 'PHARMACEUTICALS', 'POLLUTION', 'EDUCATION', 'MEMBERSHIP', 'SOLID WASTE', 'EMERGENCY SERVICES', 'MILITARY BASES', 'FORESTRY', 'FISHERIES', 'PHARMACISTS', 'COASTAL RESOURCES', 'TAX WITHHOLDING', 'STUDIES', 'STATE CONTROLLER', 'CONSERVATION', 'PUBLIC SAFETY DEPT.', 'BEACH EROSION', 'NONPROFIT', 'NAME CHANGE', 'CORPORATIONS', 'ARMED FORCES', 'SHERIFFS', 'TRAFFIC OFFENSES', 'COMMUNITY COLLEGES OFFICE', 'REFRIGERATION EXAMINERS BOARD', 'ALCOHOLIC BEVERAGES', 'LICENSES & PERMITS', 'IMMIGRATION', 'STORAGE TANKS', 'ELEMENTARY EDUCATION', 'ZOOS', 'INSPECTIONS', 'PROGRAM EVALUATION COMM.', 'SAFETY', 'PRESENTED', 'ECONOMIC DEVELOPMENT', 'PESTICIDES & HERBICIDES', 'AQUACULTURE', 'FEES', 'CONTROLLED SUBSTANCES', 'INTERSTATE COOPERATION', 'TRANSPORTATION', 'PRESIDENT PRO TEMPORE', 'WINERIES & BREWERIES', 'NC', 'BUILDING CODE COUNCIL', 'DAIRY PRODUCTS', 'GENERAL STATUTES', 'ALTERNATIVE ENERGY', 'CONFIDENTIALITY', 'SOILS', 'LAW ENFORCEMENT', 'WATER & SEWER SYSTEMS', 'CRIMINAL JUSTICE INFORMATION BD.', 'TAXES', 'PERSONNEL', 'COMMISSIONS', 'FISHERIES PRODUCTS', 'COASTAL RESOURCES COMN.', 'KINDERGARTEN', 'GOVERNOR', 'HORSE COUNCIL', 'AGRICULTURE COMMISSIONER', 'LOCAL GOVERNMENT COMN.', 'ABANDONED PROPERTY', 'DEFINITIONS', 'CONSTITUTION', 'GENERAL ASSEMBLY', 'PUBLIC', 'WORK SAFETY', 'SURPLUS PROPERTY', 'WATER RESOURCES', 'ELECTRONIC GOVERNMENT', 'AGRICULTURAL EQUIPMENT', 'INDIVIDUAL INCOME', 'GEOGRAPHY', 'COUNTIES', 'NOTIFICATION', 'TAXATION', 'LEGISLATIVE SERVICES OFFICE', 'ENVIRONMENT', 'UNREGULATED VEHICLES', 'MOTOR VEHICLES', 'FINANCIAL SERVICES', 'SPEAKER', 'BUDGET & MANAGEMENT OFFICE', 'COUNCILS', 'ENVIRONMENTAL MANAGEMENT COMN.', 'DATA SYSTEMS', 'PESTICIDE BOARD', 'SOIL & WATER CONSERVATION COMN.', 'PRODUCE', 'MIGRANT WORKERS', 'GENERAL CONTRACTORS BOARD', 'PURCHASING', 'LABOR DEPT.', 'MORTGAGES', 'LOCAL GOVERNMENT', 'HOUSING', 'ADMINISTRATIVE RULES', 'ADMINISTRATIVE CODE', 'AGRICULTURAL LAND', 'PROPERTY', 'ZONING MODERNIZATION TASK FORCE', 'FINES & PENALTIES', 'AGRICULTURE DEPT.', 'BEER & WINE', 'RENEWABLE ENERGY STUDY COMM.', 'INFORMATION TECHNOLOGY OFFICE', 'COMMUNICATIONS', 'DEQ', 'REAL ESTATE', 'RECYCLING', 'ADVERTISING', 'COMMERCE', 'LANDSCAPING', 'SALES & CONVEYANCES', 'HEALTH SERVICES', 'TASK FORCES', 'REPORTING', 'ALIENS', 'MOTOR FLEET', 'STORAGE SYSTEMS', 'BUILDINGS', 'SESSION LAWS', 'OSHA', 'SALARIES & BENEFITS', 'LICENSING & CERTIFICATION', 'ABC COMN.', 'UTILITIES', 'LANDLORD & TENANT', 'STATE VETERINARIAN'}


topic 1:
{'MITCHELL COUNTY', 'WINSTON-SALEM', 'ASHE COUNTY', 'ELEMENTARY EDUCATION', 'SECONDARY EDUCATION', 'WATAUGA COUNTY', 'EDUCATION BOARDS', 'LOCAL', 'FORSYTH COUNTY', 'CALENDAR', 'LOCAL GOVERNMENT', 'BURLINGTON', 'EDUCATION', 'ALAMANCE COUNTY', 'KINDERGARTEN', 'BOARDS', 'MCDOWELL COUNTY', 'WHITEVILLE', 'GUILFORD COUNTY', 'MUNICIPALITIES', 'PUBLIC', 'PERSON COUNTY', 'MARTIN COUNTY', 'COUNTIES', 'COLUMBUS COUNTY', 'AVERY COUNTY'}


topic 2:
{'CLEVELAND COUNTY', 'MITCHELL COUNTY', 'BRUNSWICK COUNTY', 'TRANSYLVANIA COUNTY', 'LOCAL', 'RANDOLPH COUNTY', 'CABARRUS COUNTY', 'MOORE COUNTY', 'NEW HANOVER COUNTY', 'BUNCOMBE COUNTY', 'MECKLENBURG COUNTY', 'BLANK BILL', 'BLADEN COUNTY', 'HENDERSON COUNTY', 'MADISON COUNTY', 'UNION COUNTY', 'ROBESON COUNTY', 'MCDOWELL COUNTY', 'RUTHERFORD COUNTY', 'DAVIDSON COUNTY', 'BURKE COUNTY', 'POLK COUNTY', 'YANCEY COUNTY', 'PENDER COUNTY', 'MONTGOMERY COUNTY', 'COUNTIES', 'COLUMBUS COUNTY'}


topic 3:
{'ELECTRICITY', 'PUBLIC OFFICIALS', 'FUEL', 'SURETY & FIDELITY', 'LOANS', 'RATIFIED', 'FOODS & BEVERAGES', 'TITLE CHANGE', 'COUNCIL OF STATE', 'CHAPTERED', 'ENTERTAINMENT INDUSTRY', 'CONSTRUCTION', 'HOSPITALS', 'REGISTER OF DEEDS', 'SPORTS', 'LEASING', 'UTILITIES COMN.', 'DEATH & DYING', 'TELECOMMUNICATIONS', 'MANUFACTURING', 'FOR-PROFIT', 'AGRICULTURE', 'RECORDS', 'CORPORATE INCOME', 'LDC', 'PUBLIC RECORDS', 'INFRASTRUCTURE', 'FUNDS & ACCOUNTS', 'REVENUE DEPT.', 'EXCISE', 'RECORDATION OF INSTRUMENTS', 'TAX DISTRIBUTION', 'DEEDS', 'FAMILY  ISSUES', 'RETAILING', 'INSURANCE COMMISSIONER', 'CASH CROPS', 'NONPROFIT', 'CORPORATIONS', 'TAX EXEMPTIONS', 'ALCOHOLIC BEVERAGES', 'TAX CREDITS', 'LICENSES & PERMITS', 'SALES & USE', 'TAXIS', 'PRESENTED', 'ECONOMIC DEVELOPMENT', 'FEES', 'TRANSPORTATION', 'TAX DEDUCTIONS', 'WINERIES & BREWERIES', 'NC', 'TAX REFUNDS', 'TAXES', 'TOBACCO', 'COMMISSIONS', 'SHIPPING', 'FRANCHISE', 'CONSTITUTION', 'PUBLIC', 'AGRICULTURAL EQUIPMENT', 'INDIVIDUAL INCOME', 'COUNTIES', 'TAXATION', 'RACING', 'MOTOR VEHICLES', 'FINANCIAL SERVICES', 'FUNERAL SERVICES', 'AVIATION', 'INSURANCE', 'INTEREST', 'MORTGAGES', 'LOCAL GOVERNMENT', 'CONSTRUCTION EQUIPMENT', 'HOUSING', 'FOOD SERVICES', 'PROPERTY', 'BEER & WINE', 'REAL ESTATE', 'FUELS', 'COMMERCE', 'HEALTH SERVICES', 'LICENSE', 'SESSION LAWS', 'INSURANCE DEPT.', 'UTILITIES'}


topic 4:
{'SOCIAL SERVICES DEPTS.', 'RESPITE CARE', 'DMV', 'CHIEF INFORMATION OFFICER', 'SECONDARY EDUCATION', 'RESEARCH', 'CHILD CUSTODY', 'CHILD SUPPORT', 'ONE NORTH CAROLINA FUND', 'RATIFIED', 'STATE EMPLOYEES', 'DISASTERS & EMERGENCIES', 'MEDICAL EXAMINERS', 'HISTORIC SITES & MONUMENTS', 'EMERGING TECHNOLOGIES', 'ENTERTAINMENT INDUSTRY', 'MANAGEMENT', 'CONSTRUCTION', 'UNC', 'BEACH NOURISHMENT & REPLENISHMENT', 'MONITORING & SURVEILLANCE SYSTEMS', 'PILOT PROGRAMS', 'SPORTS', 'MUNICIPALITIES', 'UTILITIES COMN.', 'DEATH BENEFITS', 'WILDLIFE RESOURCES COMN.', 'ARTS', 'HISTORICAL COMN.', 'INTERNET', 'MANUFACTURING', 'AGRICULTURAL WASTE', 'INDIGENT DEFENSE SERVICES OFFICE', 'CJE & TRAINING STANDARDS COMN.', 'JUSTICE OVERSIGHT COMM.', 'FOREST PRODUCTS', 'LDC', 'SOCIAL SERVICES', 'POVERTY', 'INFRASTRUCTURE', 'REVENUE DEPT.', 'CITIZENSHIP', 'TOBACCO PRODUCTS', 'DOMESTIC ANIMALS', 'ADMINISTRATION DEPT.', 'FISH & WILDLIFE', 'DOMESTIC VIOLENCE COMN.', 'SBI', 'BLACK MOUNTAIN', 'EDUCATION CABINET', 'MOTOR VEHICLE', 'SOCIAL SERVICES COMN.', 'TEACHERS', 'MENTAL HEALTH', 'CANCER', 'COASTAL RESOURCES', 'PUBLIC SAFETY DEPT.', 'WORKERS COMPENSATION STUDY COMM.', 'CORPORATIONS', 'HAZARDOUS WASTE', 'HOME HEALTH CARE', 'STATE TREASURER', 'LICENSE TO GIVE TRUST FUND COMN.', 'MEDICAID', 'TAX CREDITS', 'EVIDENCE', 'WOMEN', 'SAFETY', 'ECONOMIC DEVELOPMENT', 'SCHOLARSHIPS', 'HICKORY', 'FEES', 'FIREMENS PENSION FUND', 'GENERAL STATUTES', 'MONUMENTS & MEMORIALS', 'NURSING', 'SOILS', 'MINORS', 'NCWORKS COMN.', 'PARKS & RECREATION AREAS', 'PAROLE COMN.', 'TOBACCO', 'AQUARIUMS', 'LITERACY', 'SHIPPING', 'HEALTH INFORMATION EXCHANGE BOARD', 'MEDICAL RECORDS', 'AGRICULTURE RESOURCES OVERSIGHT COMM.', 'CERTIFICATES OF NEED', 'UNMANNED AIRCRAFT', 'WORK SAFETY', 'EROSION', 'COUNTIES', 'CAPITAL IMPROVEMENTS OVERSIGHT COMM.', 'ANIMAL CONTROL', 'PRINCIPALS', 'BUDGET & MANAGEMENT OFFICE', 'COUNCILS', 'TELECONFERENCING', 'BLIND COMN.', 'CLEAN WATER TRUST FUND', 'LIFE', 'AIDS', 'HOUSING', 'DOMESTIC VIOLENCE', 'FINES & PENALTIES', 'FUNDING', 'BEER & WINE', 'ZOOLOGICAL PARK COUNCIL', 'BOARD OF REVIEW', 'HOME SCHOOLING', 'COURT CLERKS', 'ASHEVILLE', 'TEXTILES', 'APPRENTICESHIPS', 'VICTIMS RIGHTS', 'LICENSING & CERTIFICATION', 'NEWTON', 'ABC COMN.', 'ANIMALS', 'APPOINTMENTS', 'PRIVATE SCHOOLS', 'EDUCATION BOARDS', 'SUNSETS', 'STATE BUILDINGS', 'INVESTIGATIONS', 'LOTTERY', 'TRIBAL GOVERNMENT', 'EDUCATION ADMINISTRATION', 'SPEED LIMIT', 'TITLE CHANGE', 'COURT OF APPEALS', 'COUNCIL OF STATE', 'ARBORETUMS & BOTANICAL GARDENS', 'APPROPRIATIONS', 'ZOO FUND', 'MAGISTRATES', 'VOCATIONAL EDUCATION', 'GOVERNMENT EMPLOYEES', 'LEASING', 'ROADS & HIGHWAYS', 'PUBLIC DEFENDERS', 'INFORMATION TECHNOLOGY DEPT.', 'COMMITTEES', 'TSERS', 'WETLANDS', 'STATE PROPERTY', 'HEALTH BENEFITS AUTHORITY BOARD', 'CRIMES', 'LT. GOVERNOR', 'BUDGETING', 'STATE HEALTH PLAN', 'BRIDGES', 'AGRICULTURE', 'PROFESSIONAL EDUCATION', 'GRANTS', 'DARE COUNTY', 'LOTTERY FUND', 'MEDICAL EQUIPMENT', 'INDUSTRIAL EQUIPMENT', 'DISEASES & HEALTH DISORDERS', 'MINING & MINERAL EXTRACTION', 'LICENSE PLATES', 'EXCISE', 'REPORTS', 'HOMICIDE', 'INDIGENTS', 'MEMBERSHIP', 'EMERGENCY SERVICES', 'CLINICS', 'TRAVEL & TOURISM', 'FALLS LAKE', 'TRUCKS', 'FORESTRY', 'MOTORCYCLES', 'TOLL ROADS & BRIDGES', 'INTERNATIONAL TRADE', 'TAX DISTRIBUTION', 'FAMILY  ISSUES', 'SECRETARY OF STATE', 'CONSERVATION', 'DIVORCE', 'TRAFFIC OFFENSES', 'ALCOHOLIC BEVERAGES', 'LABORATORIES', 'STORAGE TANKS', 'ELEMENTARY EDUCATION', 'SALES & USE', 'WATAUGA COUNTY', 'AUTHORITIES', 'CONTROLLED SUBSTANCES', 'ESCHEATS', 'INTERSTATE COOPERATION', 'TAX DEDUCTIONS', 'AUDITING & AUDITS', 'TIMBER', 'LAW ENFORCEMENT', 'SCIENCE & TECHNOLOGY', 'BOONE', 'FOSTER CARE', 'INMATES', 'PUBLIC', 'GENERAL ASSEMBLY', 'INVESTMENTS', 'MERIT SYSTEMS', 'LMES', 'ELECTRONIC GOVERNMENT', 'CHIEF JUSTICE', 'GEOGRAPHY', 'EMERGENCY MANAGEMENT', 'SUBSTANCE ABUSE', 'GENETICS', 'RACING', 'LEGISLATIVE RESEARCH COMN.', 'FRAUD', 'BICYCLES', 'CRIMINAL PROCEDURE', 'COUNSELING', 'INSURANCE', 'AVIATION', 'BIOTECHNOLOGY', 'DATA SYSTEMS', 'ADOPTION', 'LABOR DEPT.', 'ADMINISTRATIVE RULES', 'PROPERTY', 'AGRICULTURE DEPT.', 'INFORMATION TECHNOLOGY OFFICE', 'COMMUNICATIONS', 'REAL ESTATE', 'ADVERTISING', 'HEALTH BENEFITS AUTHORITY OVERSIGHT COMM.', 'COMMERCE', 'NARCOTICS', 'JORDAN LAKE', 'WORKFORCE DEVELOPMENT COMN.', 'HEALTH SERVICES', 'NEWBORNS & INFANTS', 'REPORTING', 'TASK FORCES', 'EUGENICS', 'CAMERAS', 'ADMIN. HEARINGS OFFICE', 'REVISOR OF STATUTES', 'ELECTRONIC COMMERCE', 'NATURAL RESOURCES OVERSIGHT COMM.', 'UTILITIES', 'NATIONAL GUARD', 'DAY CARE', 'SHALLOW DRAFT INLET DREDGING FUND', 'BIDS & BIDDING', 'COURT COSTS & FEES', 'SECURITIES', 'ROSE HILL', 'TRANSPORTATION DEPT.', 'PENSION & RETIREMENT FUNDS', 'PUBLIC OFFICIALS', 'FUEL', 'POLITICAL ACTIVITY', 'LOANS', 'LONGITUDINAL DATA SYSTEM BOARD', 'PAROLE & PROBATION', 'DNA', 'EMPLOYMENT', 'CHILDREN WITH SPECIAL NEEDS', 'DRIVERS LICENSES', 'WORKFORCE DEVELOPMENT BOARDS', 'CONOVER', 'NEW HANOVER COUNTY', 'MUSEUMS', 'WATER INFRASTRUCTURE AUTHORITY', 'NATURAL & CULTURAL RESOURCES DEPT.', 'HOSPITALS', 'PRIVATIZATION', 'SEDIMENTATION CONTROL COMN.', 'TURNPIKE AUTHORITY BOARD', 'WILMINGTON', 'NURSING HOME ADMIN. BOARD', 'BOARDS', 'COMMUNITY COLLEGES', 'RUTHERFORD COUNTY', 'FIREFIGHTERS & FIREFIGHTING', 'COLLEGES & UNIVERSITIES', 'TELECOMMUNICATIONS', 'TUITION', 'PUBLIC HEALTH', 'MARINE FISHERIES COMN.', 'RURAL DEVELOPMENT', 'ATTORNEY GENERAL', 'PUBLIC INSTRUCTION DEPT.', 'HORTICULTURE', 'TESTING', 'HOUSING FINANCE AGENCY', 'RULES REVIEW COMN.', "GOVERNOR'S CRIME COMN.", 'MILITARY AFFAIRS DEPT.', 'GEOGRAPHIC INFORMATION COUNCIL', 'AOC', 'RECORDS', 'ARBORETUM BOARD', 'CORPORATE INCOME', 'COMMERCE DEPT.', 'FUNDS & ACCOUNTS', 'MEDICAID OVERSIGHT COMM.', 'ALZHEIMERS', 'AGING', 'POLLUTION', 'PHARMACEUTICALS', 'VOUCHERS', 'REVENUE LAWS STUDY COMM.', 'SUPT. OF', 'UNC BOARD OF GOVERNORS', 'MILITARY BASES', 'CHARTER SCHOOLS', 'STATE AUDITOR', 'FISHERIES', 'SUPREME COURT', 'AIRCRAFT', 'GUARDIANSHIP', 'COURTS', 'ORGANIZED CRIME', 'ID SYSTEMS', 'ARCHAEOLOGY', 'RETAILING', 'ELECTIONS', 'BOXING ADVISORY COMN.', 'STUDIES', 'STATE CONTROLLER', 'STUDENTS', 'BEACH EROSION', 'UNEMPLOYMENT', 'PREGNANCY', 'NAME CHANGE', 'CAPITAL PLANNING COMN.', 'PRESENTED', 'FINANCIAL INSTITUTIONS', 'CATAWBA COUNTY', 'DISABLED PERSONS', 'TRANSPORTATION', 'ALTERNATIVE ENERGY', 'EDUCATIONAL TESTING', 'VETERANS AFFAIRS COMN.', 'CAPITAL PUNISHMENT', 'TRAVEL & TOURISM BOARD', 'DISCRIMINATION', 'CRIMINAL JUSTICE INFORMATION BD.', 'TAXES', 'SENTENCING', 'PERSONNEL', 'COMMISSIONS', 'FILM INDUSTRY', 'FISHERIES PRODUCTS', 'BIOTECHNOLOGY CENTER', 'JUDICIAL DEPT.', 'LOCAL GOVERNMENT COMN.', 'WATER RESOURCES', 'PITT COUNTY', 'INNOCENCE INQUIRY COMN.', 'INDIVIDUAL INCOME', 'HEALTH', 'TAXATION', 'HUMAN BLOOD & ORGANS', 'EDUCATION ASSISTANCE AUTHORITY', 'TRANSPORTATION BOARD', 'ENVIRONMENT', 'MOTOR VEHICLES', 'FINANCIAL SERVICES', 'LOTTERY COMN.', 'SPEAKER', 'WAKE COUNTY', 'CAPITAL SPENDING', 'RAILROADS', 'INDIGENT DEFENSE COMN.', 'BANKS', 'JUDGES', 'NURSING HOMES', 'BUNCOMBE COUNTY', 'FERRIES', 'YOUTH PROGRAMS', 'COST-OF-LIVING', 'WELFARE', 'SALES & CONVEYANCES', 'DURHAM COUNTY', 'DEBTOR & CREDITOR', 'STATE CRIME LAB', 'INFORMATION TECHNOLOGY OVERSIGHT COMM.', 'STORAGE SYSTEMS', 'PORTS', 'SALARIES & BENEFITS', 'RETIREMENT', 'CORRECTIONAL INSTITUTIONS', 'JUSTICE DEPT.', 'WORK FIRST', 'GOVERNOR', 'MORATORIUMS', 'HIGHWAY TRUST FUND', 'LAKES & RIVERS', 'INFORMATION TECHNOLOGY', 'HHS OVERSIGHT COMM.', 'HAZARDOUS SUBSTANCES', 'ADAP', 'ROANOKE ISLAND COMN.', 'CONTRACTS', 'PORTS AUTHORITY', 'RALEIGH', 'FOODS & BEVERAGES', 'VETERANS', 'CHAPTERED', 'HUMAN RELATIONS COMN.', 'MASS TRANSIT', 'GANGS', 'TEACHING SCHOLARSHIP COMN.', 'DISTANCE EDUCATION', 'HUMAN RESOURCES OFFICE', 'AGRICULTURAL FINANCE AUTHORITY', 'CRIMINAL RECORDS', 'DISTRICT COURT', 'DEATH & DYING', 'OCCUPATIONS', 'LOBBYING', 'HIGHER EDUCATION', 'STATE BOARD OF', 'ORGAN DONATIONS', 'TELESERVICES', 'ATTORNEYS', 'FOR-PROFIT', 'COOPERATIVE HIGH SCHOOL STUDY COMM.', 'TAX COLLECTION', 'CURRICULUM', 'CULTURAL RESOURCES', 'PUBLIC RECORDS', 'RESCUE SQUADS', 'TEXTBOOKS', 'WASTE MANAGEMENT', 'EDUCATION', 'HISTORIC PRESERVATION', 'MUSEUM OF ART BOARD', 'DHHS', 'PHARMACISTS', 'LITTERING', 'HALIFAX COUNTY', 'HEALTH INFORMATION EXCHANGE AUTHORITY', 'NONPROFIT', 'ARMED FORCES', 'COMMUNITY COLLEGES OFFICE', 'LICENSES & PERMITS', 'LIABILITY', 'MINORITIES', 'JURIES', 'ZOOS', 'INSPECTIONS', 'PUBLIC INSTRUCTION', 'HIGHWAY PATROL', 'AQUACULTURE', 'COMMISSIONER OF BANKS', 'TEACHER RETENTION COMN.', 'CHILD ABUSE', 'PRESIDENT PRO TEMPORE', 'EXHIBITIONS', 'DUPLIN COUNTY', 'FOOD', 'WATER & SEWER SYSTEMS', 'NEGOTIABLE INSTRUMENTS', 'GOVERNMENTAL OPERATIONS COMN.', 'KINDERGARTEN', 'BOATS & WATERCRAFT', 'FRANCHISE', 'MILITARY AFFAIRS COMN.', 'BATTLESHIP COMN.', 'WORKERS COMPENSATION', 'EARLY CHILDHOOD EDUCATION', 'SPAYING & NEUTERING', 'COURT REPORTERS', 'HIGHWAY FUND', 'VENDING MACHINES', 'DISTRICT ATTORNEYS', 'ENVIRONMENTAL MANAGEMENT COMN.', 'VACCINES', 'PARTNERSHIP FOR CHILDREN', 'PRODUCE', 'PURCHASING', 'INDUSTRIAL COMN.', 'LOCAL GOVERNMENT', 'AGRICULTURAL INSPECTION', 'ADMINISTRATIVE CODE', 'SUPERIOR COURT', 'DEQ', 'LAW ENFORCEMENT OFFICERS', 'FUELS', 'BANKING COMN.', 'HEALTH CHOICE', 'COMPACTS', 'ELECTRONIC SIGNATURES', 'PUBLIC TRANSPORTATION', 'BUILDINGS', 'SESSION LAWS', 'INSURANCE DEPT.', 'DEBT/STATE GOVERNMENT'}


topic 5:
{'COURT COSTS & FEES', 'BUDGETING', 'ATTORNEYS', 'CRIMINAL PROCEDURE', 'INFORMATION TECHNOLOGY', 'INTERNET', 'LICENSES & PERMITS', 'EVIDENCE', 'DMV', 'MOTOR VEHICLES', 'BIOTECHNOLOGY', 'WEAPONS', 'AOC', 'PRESENTED', 'RECORDS', 'SURETY & FIDELITY', 'DEVELOPMENTAL DISABILITIES', 'DATA SYSTEMS', 'FEES', 'POVERTY', 'DWI', 'FUNDS & ACCOUNTS', 'RATIFIED', 'DNA', 'TITLE CHANGE', 'INDIGENTS', 'JUDGES', 'CHAPTERED', 'APPROPRIATIONS', 'BOATING', 'DRIVERS LICENSES', 'MINORS', 'FINES & PENALTIES', 'MAGISTRATES', 'SENTENCING', 'GANGS', 'SUPERIOR COURT', 'JUDICIAL DEPT.', 'COURTS', 'ORGANIZED CRIME', 'MONITORING & SURVEILLANCE SYSTEMS', 'ID SYSTEMS', 'REPORTING', 'BOATS & WATERCRAFT', 'RECREATION & LEISURE', 'MENTAL HEALTH', 'SEX OFFENSES', 'INSTITUTIONALIZED PERSONS', 'CRIMINAL RECORDS', 'PUBLIC', 'PUBLIC DEFENDERS', 'FORENSIC SCIENCES', 'COURT CLERKS', 'DISTRICT COURT', 'FAMILY  ISSUES', 'ELECTRONIC GOVERNMENT', 'BAIL', 'JUSTICE DEPT.', 'GENETICS', 'CRIMES', 'TRAFFIC OFFENSES'}


topic 6:
{'MEDICAL BENEFITS OVERSIGHT COMM.', 'SOCIAL SERVICES DEPTS.', 'MEDICAID', 'BUDGETING', 'DIVORCE', 'STATE HEALTH PLAN', 'HHS OVERSIGHT COMM.', 'APPOINTMENTS', 'INSURANCE', 'SPEAKER', 'CHILD CUSTODY', 'PRESENTED', 'PUBLIC OFFICIALS', 'AUTHORITIES', 'SOCIAL SERVICES', 'POVERTY', 'FUNDS & ACCOUNTS', 'CONTRACTS', 'CHILD SUPPORT', 'RATIFIED', 'PRESIDENT PRO TEMPORE', 'STATE EMPLOYEES', 'PURCHASING', 'REPORTS', 'COUNCIL OF STATE', 'LOCAL GOVERNMENT', 'MEMBERSHIP', 'CHAPTERED', 'APPROPRIATIONS', 'MINORS', 'DHHS', 'HEALTH BENEFITS AUTHORITY OVERSIGHT COMM.', 'WELFARE', 'HEALTH CHOICE', 'BOARDS', 'HEALTH SERVICES', 'TEACHERS', 'MENTAL HEALTH', 'PUBLIC', 'GENERAL ASSEMBLY', 'LMES', 'COMMITTEES', 'STUDIES', 'HEALTH', 'SALARIES & BENEFITS', 'COUNTIES', 'HEALTH BENEFITS AUTHORITY BOARD', 'GOVERNOR', 'DAY CARE'}


topic 7:
{'BUDGETING', 'WOMEN', 'PUBLIC OFFICIALS', 'FUNDS & ACCOUNTS', 'STATE EMPLOYEES', 'LABOR DEPT.', 'JUDGES', 'COUNCIL OF STATE', 'EMPLOYMENT', 'DISCRIMINATION', 'APPROPRIATIONS', 'LABOR COMMISSIONER', 'MAGISTRATES', 'PERSONNEL', 'COST-OF-LIVING', 'LRS', 'COMMERCE', 'MINIMUM WAGE', 'TEACHERS', 'CJRS', 'PUBLIC', 'GENERAL ASSEMBLY', 'FAMILY  ISSUES', 'TSERS', 'SALARIES & BENEFITS', 'RETIREMENT'}


topic 8:
{'RESOLUTIONS', 'GENERAL ASSEMBLY', 'HOUSE & SENATE', 'RATIFIED', 'COMMITTEES', 'ADJOURNMENT', 'SIMPLE', 'RULES', 'ADOPTED', 'CHAPTERED', 'JOINT'}


topic 9:
{'BUDGETING', 'INTERNET', 'INFORMATION TECHNOLOGY', 'ACCOUNTING', 'PRINCIPALS', 'NUTRITION', 'APPOINTMENTS', 'ELEMENTARY EDUCATION', 'SECONDARY EDUCATION', 'CURRICULUM', 'HEALTHY YOUTH & SCHOOLS COMN.', 'PRIVATE SCHOOLS', 'SPEAKER', 'EDUCATION BOARDS', 'RECORDS', 'PUBLIC OFFICIALS', 'PUBLIC RECORDS', 'CONTRACTS', 'SCHOOL PERFORMANCE IMPROVEMENT TASK FORCE', 'EDUCATION ADMINISTRATION', 'AUDITING & AUDITS', 'PRESIDENT PRO TEMPORE', 'REPORTS', 'FOODS & BEVERAGES', 'COUNCIL OF STATE', 'LOCAL GOVERNMENT', 'EDUCATION', 'MEMBERSHIP', 'APPROPRIATIONS', 'MINORS', 'CHARTER SCHOOLS', 'COMMISSIONS', 'DHHS', 'KINDERGARTEN', 'DISTANCE EDUCATION', 'CHARTER SCHOOLS ADVISORY BOARD', 'BOARDS', 'PILOT PROGRAMS', 'REPORTING', 'SPORTS', 'HOME SCHOOLING', 'TASK FORCES', 'PUBLIC', 'GENERAL ASSEMBLY', 'HEALTH EDUCATION', 'ELECTRONIC GOVERNMENT', 'STUDENTS', 'STUDIES', 'PUBLIC HEALTH', 'GOVERNOR', 'STATE BOARD OF', 'PUBLIC INSTRUCTION DEPT.'}


topic 10:
{'ANIMALS', 'INTERNET', 'INFORMATION TECHNOLOGY', 'MOTOR VEHICLES', 'LICENSES & PERMITS', 'DMV', 'POLITICAL PARTIES', 'TRANSPORTATION DEPT.', 'COUNTY COMMISSIONERS', 'PRESENTED', 'RECORDS', 'INTEREST', 'FEES', 'CONTRACTS', 'TRANSPORTATION', 'RATIFIED', 'REVENUE DEPT.', 'LICENSE PLATES', 'TITLE CHANGE', 'WARRANTIES', 'VETERANS', 'LAW ENFORCEMENT', 'LOCAL GOVERNMENT', 'CHAPTERED', 'FINES & PENALTIES', 'PROPERTY', 'EMERGENCY SERVICES', 'MOTOR VEHICLE', 'NAMED LAWS', 'TAXES', 'PERSONNEL', 'TOWING', 'REAL ESTATE', 'CONSUMER PROTECTION', 'COMMERCE', 'SALES & CONVEYANCES', 'AUTOMOTIVE SERVICE & REPAIR', 'SPORTS', 'MOTOR FLEET', 'PUBLIC', 'RETAILING', 'STORAGE SYSTEMS', 'ELECTRONIC GOVERNMENT', 'NOTIFICATION', 'TAXATION', 'COUNTIES', 'LAW ENFORCEMENT SERVICE ANIMALS', 'ARMED FORCES'}


topic 11:
{'APPOINTMENTS', 'ELEMENTARY EDUCATION', 'POLITICAL PARTIES', 'SECONDARY EDUCATION', 'SPEAKER', 'ELECTIONS BOARDS', 'VOTER REGISTRATION', 'EDUCATION BOARDS', 'LOCAL', 'PRESENTED', 'PUBLIC OFFICIALS', 'RECORDS', 'POLITICAL ACTIVITY', 'PUBLIC RECORDS', 'PRIVACY', 'RATIFIED', 'PRESIDENT PRO TEMPORE', 'INDUSTRIAL COMN.', 'POLLUTION', 'COURT OF APPEALS', 'JUDGES', 'CALENDAR', 'LOCAL GOVERNMENT', 'CONFIDENTIALITY', 'COUNCIL OF STATE', 'EDUCATION', 'MEMBERSHIP', 'CHAPTERED', 'STANLY COUNTY', 'SUPERIOR COURT', 'COMMISSIONS', 'SUPREME COURT', 'COMMERCE', 'KINDERGARTEN', 'RECALL', 'REFERENDUMS & INITIATIVES', 'COURTS', 'BOARDS', 'PRIMARIES', 'ETHICS', 'LITTERING', 'MUNICIPALITIES', 'PUBLIC', 'GENERAL ASSEMBLY', 'DISTRICT COURT', 'ELECTIONS', 'SECRETARY OF STATE', 'ETHICS COMN.', 'REDISTRICTING', 'LOBBYING', 'COUNTIES', 'GOVERNOR', 'STATE BOARD OF', 'TERM LENGTHS & LIMITS'}


topic 12:
{'ANSON COUNTY', 'MAXTON', 'MITCHELL COUNTY', 'ENVIRONMENT', 'CITY MANAGERS', 'SILER CITY', 'PLANNING & ZONING', 'CARY', 'ANNEXATION', 'CITY COUNCILS', 'APPOINTMENTS', 'WEAPONS', 'WAKE COUNTY', 'LOCAL', 'PUBLIC OFFICIALS', 'HAYWOOD COUNTY', 'INFRASTRUCTURE', 'RATIFIED', 'FISH & WILDLIFE', 'LOCAL GOVERNMENT', 'CHAPTERED', 'PROPERTY', 'WATER & SEWER SYSTEMS', 'CHARTERS', 'COMMISSIONS', 'REAL ESTATE', 'SALES & CONVEYANCES', 'BAKERSVILLE', 'ROBESON COUNTY', 'RECREATION & LEISURE', 'CLYDE', 'MUNICIPALITIES', 'SESSION LAWS', 'NORTHAMPTON COUNTY', 'WILDLIFE RESOURCES COMN.', 'COUNTIES', 'UTILITIES', 'CHADBOURN', 'COLUMBUS COUNTY', 'POLKTON'}


topic 13:
{'RESOLUTIONS', 'CONSTITUTION', 'GENERAL ASSEMBLY', 'PUBLIC', 'MEMORIALIZING RESOLUTIONS', 'ELECTIONS', 'FOR-PROFIT', 'WOMEN', 'CAMPAIGN FINANCE', 'US', 'NC', 'COMMERCE', 'CORPORATIONS', 'DISCRIMINATION', 'JOINT'}


topic 14:
{'COMMUNITY COLLEGE BOARDS', 'UNC BOARD OF GOVERNORS', 'CHEROKEE', 'APPOINTMENTS', 'HARNETT COUNTY', 'SECONDARY EDUCATION', 'PUBLIC INSTRUCTION', 'SPEAKER', 'LOCAL', 'CHARLOTTE', 'COUNCILS', 'PUBLIC OFFICIALS', 'CULTURAL RESOURCES', 'PRESENTED', 'COUNTY COMMISSIONERS', 'EDUCATION BOARDS', 'LEE COUNTY', 'SOCIAL SERVICES', 'RATIFIED', 'PRESIDENT PRO TEMPORE', 'STATE EMPLOYEES', 'SWAIN COUNTY', 'COUNCIL OF STATE', 'CONFIRMATION', 'EMPLOYMENT', 'LOCAL GOVERNMENT', 'EDUCATION', 'MEMBERSHIP', 'CHAPTERED', 'EDUCATION CABINET', 'VOCATIONAL REHABILITATION', 'SUPT. OF', 'CHARTERS', 'MECKLENBURG COUNTY', 'MUSEUMS', 'MUSEUM OF ART BOARD', 'SCIENCE & TECHNOLOGY', 'MANAGEMENT', 'CHARTER SCHOOLS', 'NATURAL & CULTURAL RESOURCES DEPT.', 'UNC', 'PERSONNEL', 'GOVERNMENT EMPLOYEES', 'DHHS', 'CHARTER SCHOOLS ADVISORY BOARD', 'BOARDS', 'HEALTH SERVICES', 'CHATHAM COUNTY', 'COMMUNITY COLLEGES', 'RUTHERFORD COUNTY', 'MENTAL HEALTH', 'CIVIL SERVICE BOARDS', 'POLK COUNTY', 'PUBLIC', 'MUNICIPALITIES', 'COLLEGES & UNIVERSITIES', 'GENERAL ASSEMBLY', 'SCIENCE/MATH SCHOOL BOARD', 'LMES', 'STUDENTS', 'SESSION LAWS', 'ARTS', 'COUNTIES', 'HIGHER EDUCATION', 'VOCATIONAL REHAB COUNCIL', 'GOVERNOR', 'STATE BOARD OF', 'TERM LENGTHS & LIMITS', 'PUBLIC INSTRUCTION DEPT.'}

In [ ]: